| Column | Data Type | Nullable | Default | Description |
| CurrencyRateID | int | not null | | Primary key for CurrencyRate records. |
| CurrencyRateDate | datetime | not null | | Date and time the exchange rate was obtained. |
| FromCurrencyCode | nchar(3) | not null | | Exchange rate was converted from this currency code. |
| ToCurrencyCode | nchar(3) | not null | | Exchange rate was converted to this currency code. |
| AverageRate | money | not null | | Average exchange rate for the day. |
| EndOfDayRate | money | not null | | Final exchange rate for the day. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |